/**
 * 模块数据层
 * Author: 梦里小白龙 <jiangwenshu1990@126.com> <http://www.jz07.cn>
 */
var ModuleSQL = {  
    insert:'INSERT INTO module set ?', //添加数据
    getById:'SELECT * FRPM module WHERE id = ?',   //获取角色详情
    getParentId:'SELECT id,title,name FRPM module WHERE pid = ?',   //根据pid查询数据
    getByModule:'SELECT * FRPM module WHERE id = ?',   //获取详情
    updateModule:'UPDATE module SET pid = ? , title = ? , txt = ? , icon = ? , module = ? , name = ? , status = ?  WHERE id = ?',  //更新数据
    deleteModule:'DELETE FROM module WHERE id = ?',  //删除数据
};

module.exports = ModuleSQL;